package com.ocom.human.dao;

import com.ocom.common.entity.human.EntityMjKaoqin;
import icu.mhb.mybatisplus.plugln.base.mapper.JoinBaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

@Mapper
public interface IDaoMjKaoqin extends JoinBaseMapper<EntityMjKaoqin> {




    @Select({"<script>",
            " insert into mj_kaoqin (com_id,p_id,dept_id,area_id,state,create_date,create_time) \n" +
                    "select com_id,p_id,dept_id,region_id as area_id,region_online as state, #{date},#{date} \n" +
                    "from personnel_info \n" +
                    "where  com_id=#{comId}  and status =0  ",
            "</script>"})
    public void timerSave(Long comId, Date date);
}
